{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer","Assessment","Stats"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,8],[7,1,7,8]]}
[]
[null,"Disclaimer"]
[null,"SpecMaker Assessment 2024"]
[null,"Spreadsheet prepared by Dr. Gordon Gilmore "]
[null,"01/08/2009 updated 29/09/2024"]
[]
[null,"These worksheets are provided in good faith for for the convenience of gamma spectrometrists and readers of Practical Gamma-Ray Spectrometry."]
[null," The author cannot be held responsible for any inconvenience or loss of any kind arising from the use of these spreadsheets or the conclusions drawn from them."]

{"sheet":"Assessment","index":1,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[5,3,5,5],[17,6,17,7],[17,8,17,12],[17,13,17,16],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[17,2,17,5],[15,8,15,10],[16,8,16,10]]}
[]
[null,"SpecMaker - Spectrum Analysis Assessment",null,null,null,null,null,null,null,{"$f":"IF(D6<>\"\",CONCATENATE(D6, \".chn\"),\"SpecMaker Analysis\")","v":"SpecMaker Analysis"}]
[null,{"$f":"Disclaimer!B3","v":"SpecMaker Assessment 2024"},null,null,null,null,null,null,null,{"$f":"IF(E7<>\"\",E7,\"\")","v":""}]
[null,"Spreadsheet prepared by Dr. Gordon Gilmore"]
[]
[null,null,"Spectrum",null,null,null,null,"Peak Analysis"]
[null,null,null,"Program:",null,null,null,null,null,"Number of peaks created:",{"$f":"COUNT(D21:D70)","v":0}]
[null,null,null,"Version:",null,null,null,null,null,"Number of measured peaks:",{"$f":"M72","v":0}]
[null,null,null,"Date of Analysis:",null,null,null,null,null,"Number of missed peaks:",{"$f":"K7-K8","v":0}]
[null,null,null,"Comments:",null,null,null,null,null,"Number of spurious peaks:",0]
[null,null,null,null,null,null,null,null,null,"Peak Detection Index (Target =1):",{"$f":"IF(K7>0,(K8-K10)/K7,\"\")","v":""}]
[]
[null,null,"Centroid and FWHM Differences",null,null,null,null,null,"Area Estimation"]
[null,null,null,null,null,"Channels","keV",null,null,"Centroid of Distribution:",{"$f":"IF(K8>0,Stats!$L$25,\"\")","v":""}]
[null,null,null,null,"RMS Centroid Difference:",{"$f":"IF(K8>2,P72,\"\")","v":""},null,null,null,"Significance:",{"$f":"IF(K14<>\"\",Stats!L26,\"\")","v":""}]
[null,null,null,null,"RMS FWHM differences:",null,{"$f":"IF(K8>2,Q72,\"\")","v":""},null,{"$f":"IFERROR(\"\",VLOOKUP(ABS(K15),Stats!$P$12:$Q$17,2))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(K14<>\"\",Stats!M20,\"\")","v":""}]
[null,null,"Requested Values",null,null,null,"Given Values",null,"Measured Values",null,null,null,null,"Assessment"]
[null,null,"Peak Energy","Peak Area","Peak Centroid","FWHM","Peak Area","Peak Centroid","Peak Energy","Peak Area","Std. Uncert","Peak Centroid","FWHM","Peak Area","Significance","Centroid  Difference","FWHM Difference"]
[null,null,"(keV)","(counts)","(channels)","(keV)","(counts)","(channels)","(keV)","(counts)","(%)","(channels)","(keV)","z-score",null,"(channels)","(keV)"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J21<>\"\",K21<>\"\"),(J21-G21)/(K21*J21),\"\")","v":""},{"$f":"IF(N21<>\"\",VLOOKUP(ABS(N21),Stats!$P$12:$Q$17,2),\"\")","v":""},{"$f":"IF(L21<>\"\",ABS(L21-H21),\"\")","v":""},{"$f":"IF(M21<>\"\",ABS(M21-F21),\"\")","v":""}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J22<>\"\",K22<>\"\"),(J22-G22)/(K22*J22),\"\")","v":""},{"$f":"IF(N22<>\"\",VLOOKUP(ABS(N22),Stats!$P$12:$Q$17,2),\"\")","v":""},{"$f":"IF(L22<>\"\",ABS(L22-H22),\"\")","v":""},{"$f":"IF(M22<>\"\",ABS(M22-F22),\"\")","v":""}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N23<>\"\",VLOOKUP(ABS(N23),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J24<>\"\",K24<>\"\"),(J24-G24)/(K24*J24),\"\")","v":""},{"$f":"IF(N24<>\"\",VLOOKUP(ABS(N24),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N25<>\"\",VLOOKUP(ABS(N25),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N26<>\"\",VLOOKUP(ABS(N26),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N27<>\"\",VLOOKUP(ABS(N27),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,8,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N28<>\"\",VLOOKUP(ABS(N28),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,9,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N29<>\"\",VLOOKUP(ABS(N29),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,10,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N30<>\"\",VLOOKUP(ABS(N30),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,11,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N31<>\"\",VLOOKUP(ABS(N31),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,12,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N32<>\"\",VLOOKUP(ABS(N32),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,13,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N33<>\"\",VLOOKUP(ABS(N33),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,14,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N34<>\"\",VLOOKUP(ABS(N34),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,15,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N35<>\"\",VLOOKUP(ABS(N35),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,16,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N36<>\"\",VLOOKUP(ABS(N36),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,17,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N37<>\"\",VLOOKUP(ABS(N37),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,18,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N38<>\"\",VLOOKUP(ABS(N38),Stats!$P$12:$Q$17,2),\"\")","v":""},{"$f":"IF(L38<>\"\",ABS(L38-H38),\"\")","v":""},""]
[null,19,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N39<>\"\",VLOOKUP(ABS(N39),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,20,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N40<>\"\",VLOOKUP(ABS(N40),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,21,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N41<>\"\",VLOOKUP(ABS(N41),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,22,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N42<>\"\",VLOOKUP(ABS(N42),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,23,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N43<>\"\",VLOOKUP(ABS(N43),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,24,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N44<>\"\",VLOOKUP(ABS(N44),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,25,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N45<>\"\",VLOOKUP(ABS(N45),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,26,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N46<>\"\",VLOOKUP(ABS(N46),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,27,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N47<>\"\",VLOOKUP(ABS(N47),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,28,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N48<>\"\",VLOOKUP(ABS(N48),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,29,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N49<>\"\",VLOOKUP(ABS(N49),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,30,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N50<>\"\",VLOOKUP(ABS(N50),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,31,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N51<>\"\",VLOOKUP(ABS(N51),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,32,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N52<>\"\",VLOOKUP(ABS(N52),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,33,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N53<>\"\",VLOOKUP(ABS(N53),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,34,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N54<>\"\",VLOOKUP(ABS(N54),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N55<>\"\",VLOOKUP(ABS(N55),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,36,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N56<>\"\",VLOOKUP(ABS(N56),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,37,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N57<>\"\",VLOOKUP(ABS(N57),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,38,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N58<>\"\",VLOOKUP(ABS(N58),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,39,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N59<>\"\",VLOOKUP(ABS(N59),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N60<>\"\",VLOOKUP(ABS(N60),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,41,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N61<>\"\",VLOOKUP(ABS(N61),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,42,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N62<>\"\",VLOOKUP(ABS(N62),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,43,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N63<>\"\",VLOOKUP(ABS(N63),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,44,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N64<>\"\",VLOOKUP(ABS(N64),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,45,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N65<>\"\",VLOOKUP(ABS(N65),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,46,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N66<>\"\",VLOOKUP(ABS(N66),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,47,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N67<>\"\",VLOOKUP(ABS(N67),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,48,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N68<>\"\",VLOOKUP(ABS(N68),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,49,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N69<>\"\",VLOOKUP(ABS(N69),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,50,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(N70<>\"\",VLOOKUP(ABS(N70),Stats!$P$12:$Q$17,2),\"\")","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Centroid","FWHM"]
[null,null,null,null,null,"Mean:",{"$f":"IF($M$72=0,\"\",AVERAGE(G21:G70))","v":""},null,"Mean:",{"$f":"IF($M$72=0,\"\",AVERAGE(J21:J70))","v":""},{"$f":"IF($M$72=0,\"\",AVERAGE(K21:K70))","v":""},"Number:",{"$f":"COUNT(L21:L70)","v":0},null,"Average Deviations",{"$f":"IF($M$72=0,\"\",AVERAGE(P21:P70))","v":""},{"$f":"IF($M$72=0,\"\",AVERAGE(Q21:Q70))","v":""}]
[null,null,null,null,null,"Stdev:",{"$f":"IF($M$72=0,\"\",STDEV(G21:G70))","v":""},null,"Stdev:",{"$f":"IF($M$72=0,\"\",STDEV(J21:J70))","v":""},{"$f":"IF($M$72=0,\"\",STDEV(K21:K70))","v":""}]
[null,null,null,null,null,"%RSD:",{"$f":"IF($M$72=0,\"\",G73/G72)","v":""},null,"%RSD:",{"$f":"IF($M$72=0,\"\",J73/J72)","v":""},{"$f":"IF($M$72=0,\"\",K73/K72)","v":""}]

{"sheet":"Stats","index":2,"n_rows":57,"n_cols":22,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Assessment of Peak Area Measurements"]
[null,null,"Measured","%RSD","Ratio",null,"Z-score",null,null,{"$f":"Assessment!J2","v":"SpecMaker Analysis"},null,null,null,null,null,null,null,null,null,null,"Bins Plot data"]
[null,"Averages:",{"$f":"AVERAGE(C8:C57)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D8:D57)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E57)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G57)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Assessment!J3","v":""},null,null,null,null,null,null,null,null,null,null,-3.5,0]
[null,"St. Unc:",{"$f":"STDEV(C8:C57)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(D8:D57)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(E8:E57)","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(F8:F57)","v":0},null," ",null,null,"Number",null,null,null,null,null,null,null,null,null,-3.5,5.977006485076819E-3]
[null,"RSD%",{"$f":"C4/C3","v":{"$error":"#DIV/0!"}},{"$f":"D4/D3","v":{"$error":"#DIV/0!"}},{"$f":"E4/E3","v":{"$error":"#DIV/0!"}},"Peaks",null,null,{"$f":"E4","v":{"$error":"#DIV/0!"}},"Bin","in Bin",null,"Fraction","Theoretical",null,"Dist Centre",null,null,null,null,-2.5,5.977006485076819E-3]
[null,null,null,null,null,null,null,null,{"$f":"I7-$E$4","v":{"$error":"#DIV/0!"}},-4,{"$f":"FREQUENCY(E8:E56,I6:I15)","v":0},{"$f":"(J6-0.5)*K6","v":0},{"$f":"K6/$K$17","v":{"$error":"#N/A"}},2.2927257060689765E-4,null,"Plot Limits",null,null,null,null,-2.5,0]
["Item","Expected","Measured","%RSD","Ratio","Diff","Z-score",null,{"$error":"#DIV/0!"},-3,0,{"$f":"J7*K7","v":0},{"$f":"K7/$K$17","v":{"$error":"#N/A"}},5.977006485076819E-3,null,0,0,null,null,null,-2.5,6.0597548934704926E-2]
[{"$f":"IF(B8<>\"\",1,\"\")","v":1},{"$f":"Assessment!G21","v":0},{"$f":"IF(Assessment!J21<>\"\",Assessment!J21,\"\")","v":""},{"$f":"IF(C8<>\"\",Assessment!K21,\"\")","v":""},{"$f":"IF(C8<>\"\",C8/B8,\"\")","v":""},{"$f":"IF(C8<>\"\",C8-B8,\"\")","v":""},{"$f":"IF(C8<>\"\",(C8-B8)/(C8*D8),\"\")","v":""},null,{"$f":"I9-$E$4","v":{"$error":"#DIV/0!"}},-2,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.0597548934704926E-2,null,0,25,null,null,null,-1.5,6.0597548934704926E-2]
[{"$f":"IF(B9<>\"\",A8+1,\"\")","v":2},{"$f":"Assessment!G22","v":0},{"$f":"IF(Assessment!J22<>\"\",Assessment!J22,\"\")","v":""},{"$f":"IF(C9<>\"\",Assessment!K22,\"\")","v":""},{"$f":"IF(C9<>\"\",C9/B9,\"\")","v":""},{"$f":"IF(C9<>\"\",C9-B9,\"\")","v":""},{"$f":"IF(C9<>\"\",(C9-B9)/(C9*D9),\"\")","v":""},null,{"$f":"1-E4/2","v":{"$error":"#DIV/0!"}},-1,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.24173030384225858,null,{"$f":"L25","v":{"$error":"#N/A"}},0,null,null,null,-1.5,0]
[3,{"$f":"Assessment!G23","v":0},{"$f":"IF(Assessment!J23<>\"\",Assessment!J23,\"\")","v":""},{"$f":"IF(C10<>\"\",Assessment!K23,\"\")","v":""},"","","",null,{"$f":"1+E4/2","v":{"$error":"#DIV/0!"}},0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.38292493472858191,null,{"$f":"P9","v":{"$error":"#N/A"}},25,null,null,null,-1.5,0.24173030384225858]
[4,{"$f":"Assessment!G24","v":0},{"$f":"IF(Assessment!J24<>\"\",Assessment!J24,\"\")","v":""},{"$f":"IF(C11<>\"\",Assessment!K24,\"\")","v":""},"","","",null,{"$f":"I10+$E$4","v":{"$error":"#DIV/0!"}},1,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.24173030384225835,null,null,null,null,null,null,-0.5,0.24173030384225858]
[5,{"$f":"Assessment!G25","v":0},{"$f":"IF(Assessment!J25<>\"\",Assessment!J25,\"\")","v":""},{"$f":"IF(C12<>\"\",Assessment!K25,\"\")","v":""},"","","",null,{"$f":"I11+$E$4","v":{"$error":"#DIV/0!"}},2,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.0597548934704926E-2,null,0," ",null,null,null,-0.5,0]
[6,{"$f":"Assessment!G26","v":0},{"$f":"IF(Assessment!J26<>\"\",Assessment!J26,\"\")","v":""},{"$f":"IF(C13<>\"\",Assessment!K26,\"\")","v":""},"","","",null,{"$error":"#DIV/0!"},3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5.977006485076819E-3,null,1,"May be significant at 84%",null,null,null,-0.5,0.38292493472858191]
[7,{"$f":"Assessment!G27","v":0},{"$f":"IF(Assessment!J27<>\"\",Assessment!J27,\"\")","v":""},{"$f":"IF(C14<>\"\",Assessment!K27,\"\")","v":""},"","","",null,{"$error":"#DIV/0!"},4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.2927257060689765E-4,null,1.282,"Significant at 90%",null,null,null,0.5,0.38292493472858191]
[8,{"$f":"Assessment!G28","v":0},{"$f":"IF(Assessment!J28<>\"\",Assessment!J28,\"\")","v":""},{"$f":"IF(C15<>\"\",Assessment!K28,\"\")","v":""},"","","",null,{"$error":"#DIV/0!"},5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2.2927257060689765E-4,null,1.645,"Significant at 95%",null,null,null,0.5,0]
[9,{"$f":"Assessment!G29","v":0},{"$f":"IF(Assessment!J29<>\"\",Assessment!J29,\"\")","v":""},{"$f":"IF(C16<>\"\",Assessment!K29,\"\")","v":""},"","","",null,{"$error":"#DIV/0!"},6,null,null,null,null,null,2.2360000000000002,"Significant at 99%",null,null,null,0.5,0.24173030384225835]
[10,{"$f":"Assessment!G30","v":0},{"$f":"IF(Assessment!J30<>\"\",Assessment!J30,\"\")","v":""},{"$f":"IF(C17<>\"\",Assessment!K30,\"\")","v":""},"","","",null,"Totals:",null,{"$f":"SUM(_xlfn.ANCHORARRAY(K6))","v":{"$error":"#N/A"}},{"$f":"SUM(L6:L15)/K17","v":{"$error":"#N/A"}},null,null,null,3,"Significant at 99.9%",null,null,null,1.5,0.24173030384225835]
[11,{"$f":"Assessment!G31","v":0},{"$f":"IF(Assessment!J31<>\"\",Assessment!J31,\"\")","v":""},{"$f":"IF(C18<>\"\",Assessment!K31,\"\")","v":""},"","","",null,null,null,"Total","Av. Posn",null,null,null,null,null,null,null,null,1.5,0]
[12,{"$f":"Assessment!G32","v":0},{"$f":"IF(Assessment!J32<>\"\",Assessment!J32,\"\")","v":""},{"$f":"IF(C19<>\"\",Assessment!K32,\"\")","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,6.0597548934704926E-2]
[13,{"$f":"Assessment!G33","v":0},{"$f":"IF(Assessment!J33<>\"\",Assessment!J33,\"\")","v":""},{"$f":"IF(C20<>\"\",Assessment!K33,\"\")","v":""},"","","",null,null,null,"Mean Count  Ratio",{"$f":"AVERAGE(E8:E57)","v":{"$error":"#DIV/0!"}},{"$f":"CONCATENATE(\"Mean Ratio: \",ROUND(L20,3),\" (\",TEXT(L23,\"0.00%\"),\")\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2.5,6.0597548934704926E-2]
[14,{"$f":"Assessment!G34","v":0},{"$f":"IF(Assessment!J34<>\"\",Assessment!J34,\"\")","v":""},{"$f":"IF(C21<>\"\",Assessment!K34,\"\")","v":""},"","","",null,null,null,"Uncertainty of Ratio",{"$f":"STDEV(E8:E57)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,2.5,0]
[15,{"$f":"Assessment!G35","v":0},{"$f":"IF(Assessment!J35<>\"\",Assessment!J35,\"\")","v":""},{"$f":"IF(C22<>\"\",Assessment!K35,\"\")","v":""},{"$f":"IF(C22<>\"\",C22/B22,\"\")","v":""},{"$f":"IF(C22<>\"\",C22-B22,\"\")","v":""},"",null,null,null,"Significance",{"$f":"(L20-1)/L21","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(ABS(L22),Stats!$P$12:$Q$17,2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,2.5,5.977006485076819E-3]
[16,{"$f":"Assessment!G36","v":0},{"$f":"IF(Assessment!J36<>\"\",Assessment!J36,\"\")","v":""},{"$f":"IF(C23<>\"\",Assessment!K36,\"\")","v":""},"","","",null,null,null,"%RSD of Ratio",{"$f":"L21/L20","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,3.5,5.977006485076819E-3]
[17,{"$f":"Assessment!G37","v":0},{"$f":"IF(Assessment!J37<>\"\",Assessment!J37,\"\")","v":""},{"$f":"IF(C24<>\"\",Assessment!K37,\"\")","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,0]
[18,{"$f":"Assessment!G38","v":0},{"$f":"IF(Assessment!J38<>\"\",Assessment!J38,\"\")","v":""},{"$f":"IF(C25<>\"\",Assessment!K38,\"\")","v":""},"","","",null,null,null,"Centroid of Distribution",{"$f":"L17","v":{"$error":"#N/A"}}]
[19,{"$f":"Assessment!G39","v":0},{"$f":"IF(Assessment!J39<>\"\",Assessment!J39,\"\")","v":""},{"$f":"IF(C26<>\"\",Assessment!K39,\"\")","v":""},"","","",null,null,null,"Significance",{"$f":"(L20-1)/L21","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(ABS(L26),Stats!$P$12:$Q$17,2)","v":{"$error":"#DIV/0!"}}]
[20,{"$f":"Assessment!G40","v":0},{"$f":"IF(Assessment!J40<>\"\",Assessment!J40,\"\")","v":""},{"$f":"IF(C27<>\"\",Assessment!K40,\"\")","v":""},"","","",null,null,null,"Number of Peaks",{"$f":"COUNT(F8:F57)","v":0}]
[21,{"$f":"Assessment!G41","v":0},{"$f":"IF(Assessment!J41<>\"\",Assessment!J41,\"\")","v":""},{"$f":"IF(C28<>\"\",Assessment!K41,\"\")","v":""},"","","",null,null,null,"Mean z-score",{"$f":"AVERAGE(G8:G57)","v":{"$error":"#DIV/0!"}}]
[22,{"$f":"Assessment!G42","v":0},{"$f":"IF(Assessment!J42<>\"\",Assessment!J42,\"\")","v":""},{"$f":"IF(C29<>\"\",Assessment!K42,\"\")","v":""},"","",""]
[23,{"$f":"Assessment!G43","v":0},{"$f":"IF(Assessment!J43<>\"\",Assessment!J43,\"\")","v":""},{"$f":"IF(C30<>\"\",Assessment!K43,\"\")","v":""},"","",""]
[24,{"$f":"Assessment!G44","v":0},{"$f":"IF(Assessment!J44<>\"\",Assessment!J44,\"\")","v":""},{"$f":"IF(C31<>\"\",Assessment!K44,\"\")","v":""},"","",""]
[25,{"$f":"Assessment!G45","v":0},{"$f":"IF(Assessment!J45<>\"\",Assessment!J45,\"\")","v":""},{"$f":"IF(C32<>\"\",Assessment!K45,\"\")","v":""},"","",""]
[26,{"$f":"Assessment!G46","v":0},{"$f":"IF(Assessment!J46<>\"\",Assessment!J46,\"\")","v":""},{"$f":"IF(C33<>\"\",Assessment!K46,\"\")","v":""},"","",""]
[27,{"$f":"Assessment!G47","v":0},{"$f":"IF(Assessment!J47<>\"\",Assessment!J47,\"\")","v":""},{"$f":"IF(C34<>\"\",Assessment!K47,\"\")","v":""},"","",""]
[28,{"$f":"Assessment!G48","v":0},{"$f":"IF(Assessment!J48<>\"\",Assessment!J48,\"\")","v":""},{"$f":"IF(C35<>\"\",Assessment!K48,\"\")","v":""},"","",""]
[29,{"$f":"Assessment!G49","v":0},{"$f":"IF(Assessment!J49<>\"\",Assessment!J49,\"\")","v":""},{"$f":"IF(C36<>\"\",Assessment!K49,\"\")","v":""},"","",""]
[30,{"$f":"Assessment!G50","v":0},{"$f":"IF(Assessment!J50<>\"\",Assessment!J50,\"\")","v":""},{"$f":"IF(C37<>\"\",Assessment!K50,\"\")","v":""},"","",""]
[31,{"$f":"Assessment!G51","v":0},{"$f":"IF(Assessment!J51<>\"\",Assessment!J51,\"\")","v":""},{"$f":"IF(C38<>\"\",Assessment!K51,\"\")","v":""},"","",""]
[32,{"$f":"Assessment!G52","v":0},{"$f":"IF(Assessment!J52<>\"\",Assessment!J52,\"\")","v":""},{"$f":"IF(C39<>\"\",Assessment!K52,\"\")","v":""},"","",""]
[33,{"$f":"Assessment!G53","v":0},{"$f":"IF(Assessment!J53<>\"\",Assessment!J53,\"\")","v":""},{"$f":"IF(C40<>\"\",Assessment!K53,\"\")","v":""},"","",""]
[{"$f":"IF(B41<>\"\",A40+1,\"\")","v":34},{"$f":"Assessment!G54","v":0},{"$f":"IF(Assessment!J54<>\"\",Assessment!J54,\"\")","v":""},{"$f":"IF(C41<>\"\",Assessment!K54,\"\")","v":""},"","",""]
[35,{"$f":"Assessment!G55","v":0},{"$f":"IF(Assessment!J55<>\"\",Assessment!J55,\"\")","v":""},{"$f":"IF(C42<>\"\",Assessment!K55,\"\")","v":""},"","",""]
[36,{"$f":"Assessment!G56","v":0},{"$f":"IF(Assessment!J56<>\"\",Assessment!J56,\"\")","v":""},{"$f":"IF(C43<>\"\",Assessment!K56,\"\")","v":""},"","",""]
[37,{"$f":"Assessment!G57","v":0},{"$f":"IF(Assessment!J57<>\"\",Assessment!J57,\"\")","v":""},{"$f":"IF(C44<>\"\",Assessment!K57,\"\")","v":""},"","",""]
[38,{"$f":"Assessment!G58","v":0},{"$f":"IF(Assessment!J58<>\"\",Assessment!J58,\"\")","v":""},{"$f":"IF(C45<>\"\",Assessment!K58,\"\")","v":""},"","",""]
[39,{"$f":"Assessment!G59","v":0},{"$f":"IF(Assessment!J59<>\"\",Assessment!J59,\"\")","v":""},{"$f":"IF(C46<>\"\",Assessment!K59,\"\")","v":""},"","",""]
[40,{"$f":"Assessment!G60","v":0},{"$f":"IF(Assessment!J60<>\"\",Assessment!J60,\"\")","v":""},{"$f":"IF(C47<>\"\",Assessment!K60,\"\")","v":""},"","",""]
[41,{"$f":"Assessment!G61","v":0},{"$f":"IF(Assessment!J61<>\"\",Assessment!J61,\"\")","v":""},{"$f":"IF(C48<>\"\",Assessment!K61,\"\")","v":""},"","",""]
[42,{"$f":"Assessment!G62","v":0},{"$f":"IF(Assessment!J62<>\"\",Assessment!J62,\"\")","v":""},{"$f":"IF(C49<>\"\",Assessment!K62,\"\")","v":""},"","",""]
[43,{"$f":"Assessment!G63","v":0},{"$f":"IF(Assessment!J63<>\"\",Assessment!J63,\"\")","v":""},{"$f":"IF(C50<>\"\",Assessment!K63,\"\")","v":""},"","",""]
[44,{"$f":"Assessment!G64","v":0},{"$f":"IF(Assessment!J64<>\"\",Assessment!J64,\"\")","v":""},{"$f":"IF(C51<>\"\",Assessment!K64,\"\")","v":""},"","",""]
[45,{"$f":"Assessment!G65","v":0},{"$f":"IF(Assessment!J65<>\"\",Assessment!J65,\"\")","v":""},{"$f":"IF(C52<>\"\",Assessment!K65,\"\")","v":""},"","",""]
[46,{"$f":"Assessment!G66","v":0},{"$f":"IF(Assessment!J66<>\"\",Assessment!J66,\"\")","v":""},{"$f":"IF(C53<>\"\",Assessment!K66,\"\")","v":""},"","",""]
[47,{"$f":"Assessment!G67","v":0},{"$f":"IF(Assessment!J67<>\"\",Assessment!J67,\"\")","v":""},{"$f":"IF(C54<>\"\",Assessment!K67,\"\")","v":""},"","",""]
[48,{"$f":"Assessment!G68","v":0},{"$f":"IF(Assessment!J68<>\"\",Assessment!J68,\"\")","v":""},{"$f":"IF(C55<>\"\",Assessment!K68,\"\")","v":""},"","",""]
[49,{"$f":"Assessment!G69","v":0},{"$f":"IF(Assessment!J69<>\"\",Assessment!J69,\"\")","v":""},{"$f":"IF(C56<>\"\",Assessment!K69,\"\")","v":""},"","",""]
[50,{"$f":"Assessment!G70","v":0},{"$f":"IF(Assessment!J70<>\"\",Assessment!J70,\"\")","v":""},{"$f":"IF(C57<>\"\",Assessment!K70,\"\")","v":""},"","",""]